Verifying that the master encryption key is encrypting the database
After configuring the master encryption key, you can verify that the master encryption key is encrypting the database, as expected.
To verify that the master encryption key is encrypting the database
-
Verify that the master encryption key is successfully encrypting table columns.
-
Create a CUSTOMERS table in the database.
sqlplus / as sysdba
connect system/Temp1234
-
Input values into the CUSTOMERS table.
-
Encrypt the CREDIT_LIMIT column of the CUSTOMERS table.
-
Return the values listed in the encrypted column in clear text.
Transparent data encryption decrypts the values automatically.
-
List the encrypted columns in your database.
-
Finally, retrieve information about the hardware keystore.
-
-
Verify that the master encryption key is successfully encrypting tablespaces.
-
Create an encrypted tablespace.
OR
-
Create a table in the tablespace.
-
Insert some values in EMPLOYEE table.
-
Display the contents of the EMPLOYEE table.
-
Close the keystore.
-
Run the command to display the contents once again.
If the keystore is closed, you will get the following error:
This error means you cannot list the contents of EMPLOYEE table.
-
Open the keystore.
-